Summary
Database developers have long understood the importance of designing a database to scale appropriately to accommodate future requirements. When developing a Microsoft Access 2000 database, it's important to consider which engine the database will use: Microsoft Jet 4.0 or Microsoft Data Engine (MSDE), a new engine that offers increased scalability and reliability, plus compatibility with Microsoft SQL Server™ 7.0. This white paper gives background information about the advantages of using Access 2000, plus helps you choose the best engine for a database by comparing the two engines in terms of enterprise requirements, usage patterns, and features.